﻿<?xml version="1.0" encoding="utf-8" ?>
<Structure>
    <TableStructure>
        <Table Name="AVA_OWST" Description="审批级别" Type="bott_MasterData" State="bots_User">
            <Field Name="AppCode" Description="名称" DataType="db_Alpha" SubType="st_None" EditSize="30" DefValue="" LinkTable="" />
            <Field Name="AppName" Description="描述" DataType="db_Alpha" SubType="st_None" EditSize="100" DefValue="" LinkTable="" />
            <Field Name="MaxReqr" Description="审批人数" DataType="db_Numeric" SubType="st_None" EditSize="8" DefValue="1" LinkTable="" />
            <Field Name="Remarks" Description="备注" DataType="db_Memo" SubType="st_None" EditSize="4000" DefValue="" LinkTable="" />
        </Table>
        <Table Name="AVA_WST1" Description="审批级别-审批者" Type="bott_MasterDataLines" State="bots_User">
            <Field Name="UserID" Description="创建人" DataType="db_Numeric" SubType="st_None" EditSize="8" DefValue="" LinkTable="" />
            <Field Name="DeptID" Description="部门编码" DataType="db_Numeric" SubType="st_None" EditSize="8" DefValue="" LinkTable="" />
        </Table>


        <Table Name="AVA_OWTM" Description="审批模板" Type="bott_MasterData" State="bots_User">
            <Field Name="AppCode" Description="名称" DataType="db_Alpha" SubType="st_None" EditSize="30" DefValue="" LinkTable="" />
            <Field Name="AppName" Description="描述" DataType="db_Alpha" SubType="st_None" EditSize="100" DefValue="" LinkTable="" />
            <Field Name="Condition" Description="是否有条件" DataType="db_Alpha" SubType="st_None" EditSize="1" DefValue="N" LinkTable="" >
                <ValidValue Value="Y" Description="是" />
                <ValidValue Value="N" Description="否" />
            </Field>
            <Field Name="Active" Description="活动" DataType="db_Alpha" SubType="st_None" EditSize="1" DefValue="Y" LinkTable="" >
                <ValidValue Value="Y" Description="是" />
                <ValidValue Value="N" Description="否" />
            </Field>
            <Field Name="Remarks" Description="备注" DataType="db_Memo" SubType="st_None" EditSize="4000" DefValue="" LinkTable="" />
        </Table>
        <Table Name="AVA_WTM1" Description="审批创建人" Type="bott_MasterDataLines" State="bots_User">
            <Field Name="UserID" Description="创建人" DataType="db_Numeric" SubType="st_None" EditSize="8" DefValue="" LinkTable="" />
            <Field Name="DeptID" Description="部门编码" DataType="db_Numeric" SubType="st_None" EditSize="8" DefValue="" LinkTable="" />
        </Table>
        <Table Name="AVA_WTM2" Description="审批阶段" Type="bott_MasterDataLines" State="bots_User">
            <Field Name="WstCode" Description="确认级别" DataType="db_Alpha" SubType="st_None" EditSize="30" DefValue="" LinkTable="" />
            <Field Name="WstName" Description="确认级别描述" DataType="db_Alpha" SubType="st_None" EditSize="100" DefValue="" LinkTable="" />
            <Field Name="SortID" Description="顺序" DataType="db_Numeric" SubType="st_None" EditSize="8" DefValue="" LinkTable="" />
        </Table>
        <Table Name="AVA_WTM3" Description="审批对象" Type="bott_MasterDataLines" State="bots_User">
            <Field Name="Selected" Description="选中" DataType="db_Alpha" SubType="st_None" EditSize="1" DefValue="" LinkTable="" >
                <ValidValue Value="Y" Description="是" />
                <ValidValue Value="N" Description="否" />
            </Field>
            <Field Name="TransType" Description="订单类型" DataType="db_Alpha" SubType="st_None" EditSize="30" DefValue="" LinkTable="" />
            <Field Name="TransName" Description="订单类型描述" DataType="db_Alpha" SubType="st_None" EditSize="100" DefValue="" LinkTable="" />
        </Table>
        <Table Name="AVA_WTM4" Description="审批条件" Type="bott_MasterDataLines" State="bots_User">
            <Field Name="ConditionID" Description="ConditionID" DataType="db_Alpha" SubType="st_None" EditSize="30" DefValue="" LinkTable="" />
            <Field Name="ConditionName" Description="ConditionName" DataType="db_Alpha" SubType="st_None" EditSize="100" DefValue="" LinkTable="" />
            <Field Name="Remarks" Description="备注" DataType="db_Alpha" SubType="st_None" EditSize="100" DefValue="" LinkTable="" />
        </Table>
        
        <Table Name="AVA_OWDD" Description="审批数据" Type="bott_MasterData" State="bots_User">
            <Field Name="Status" Description="是否批准" DataType="db_Alpha" SubType="st_None" EditSize="1" DefValue="P" LinkTable="" >
                <ValidValue Value="P" Description="处理中" />
                <ValidValue Value="C" Description="完成" />
            </Field>
            <Field Name="OwnerID" Description="创建人" DataType="db_Numeric" SubType="st_None" EditSize="8" DefValue="" LinkTable="" />
            <Field Name="OrderType" Description="单据类型" DataType="db_Alpha" SubType="st_None" EditSize="30" DefValue="" LinkTable="" />

            <Field Name="DocEntry" Description="单据编号" DataType="db_Numeric" SubType="st_None" EditSize="8" DefValue="" LinkTable="" />
            <Field Name="SerialNum" Description="流水号" DataType="db_Alpha" SubType="st_None" EditSize="30" DefValue="" LinkTable="" />
            <Field Name="OrderDate" Description="单据创建日期" DataType="db_Date" SubType="st_None" EditSize="8" DefValue="" LinkTable="" />
            <Field Name="DocDate" Description="请求日期" DataType="db_Date" SubType="st_None" EditSize="8" DefValue="" LinkTable="" />
            <Field Name="WtmCode" Description="审批模板" DataType="db_Alpha" SubType="st_None" EditSize="30" DefValue="" LinkTable="" />
            <Field Name="WstCode" Description="审批阶段" DataType="db_Alpha" SubType="st_None" EditSize="30" DefValue="" LinkTable="" />
            <Field Name="AppCode" Description="审批人" DataType="db_Alpha" SubType="st_None" EditSize="30" DefValue="" LinkTable="" />
            <Field Name="Enquire" Description="请求批准描述" DataType="db_Memo" SubType="st_None" EditSize="4000" DefValue="" LinkTable="" />
            <Field Name="AppStatus" Description="是否批准" DataType="db_Alpha" SubType="st_None" EditSize="1" DefValue="" LinkTable="" >
                <ValidValue Value="Y" Description="是" />
                <ValidValue Value="N" Description="否" />
            </Field>
            <Field Name="Response" Description="答复" DataType="db_Memo" SubType="st_None" EditSize="4000" DefValue="" LinkTable="" />
            <Field Name="Remarks" Description="备注" DataType="db_Memo" SubType="st_None" EditSize="4000" DefValue="" LinkTable="" />
        </Table>
        <Table Name="AVA_WDD1" Description="审批过程" Type="bott_MasterDataLines" State="bots_User">
            <Field Name="WstCode" Description="审批阶段" DataType="db_Alpha" SubType="st_None" EditSize="30" DefValue="" LinkTable="" />
            <Field Name="UserID" Description="审批者" DataType="db_Numeric" SubType="st_None" EditSize="8" DefValue="" LinkTable="" />
            <Field Name="Response" Description="答复" DataType="db_Memo" SubType="st_None" EditSize="4000" DefValue="" LinkTable="" />
            <Field Name="ResponseDate" Description="答复日期" DataType="db_Date" SubType="st_None" EditSize="8" DefValue="" LinkTable="" />
            <Field Name="ResponseTime" Description="答复时间" DataType="db_Date" SubType="st_Time" EditSize="8" DefValue="" LinkTable="" />
        </Table>
    </TableStructure>
    <ObjectStructure>
        <Object Code="AVA_ApprovalStages" Name="审批级别" TableName="AVA_OWST" ObjectType="boud_MasterData" LogTableName="" CanFind="Yes" CanCancel="No" CanClose="No" CanDelete="Yes" CanYearTransfer="Yes" ManageSeries="Yes">
            <ChildTables>
                <ChildTable TableName="AVA_WST1" LogTableName="" />
            </ChildTables>
            <FindColumns />
            <FormColumns />
        </Object>
        <Object Code="AVA_ApprovalTem" Name="审批模板" TableName="AVA_OWTM" ObjectType="boud_MasterData" LogTableName="" CanFind="Yes" CanCancel="No" CanClose="No" CanDelete="Yes" CanYearTransfer="Yes" ManageSeries="Yes">
            <ChildTables>
                <ChildTable TableName="AVA_WTM1" LogTableName="" />
                <ChildTable TableName="AVA_WTM2" LogTableName="" />
                <ChildTable TableName="AVA_WTM3" LogTableName="" />
                <ChildTable TableName="AVA_WTM4" LogTableName="" />
            </ChildTables>
            <FindColumns />
            <FormColumns />
        </Object>
        <Object Code="AVA_ApprovalStep" Name="审批过程" TableName="AVA_OWDD" ObjectType="boud_MasterData" LogTableName="" CanFind="Yes" CanCancel="Yes" CanClose="No" CanDelete="No" CanYearTransfer="Yes" ManageSeries="Yes">
            <ChildTables>
                <ChildTable TableName="AVA_WDD1" LogTableName="" />
            </ChildTables>
            <FindColumns />
            <FormColumns />
        </Object>
    </ObjectStructure>
</Structure>